﻿<%@ Page Language="C#" MasterPageFile="~/ana.master" AutoEventWireup="true" CodeFile="sayfagoster.aspx.cs" Inherits="Default2" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
  
   
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:MultiView ID="MultiView1" runat="server">
        <asp:View ID="View1" runat="server">
        <table cellpadding="0" cellspacing="0" width="100%" bgcolor="white">
        <tr>
            <td>
                <b>KASKO</b></td>
        </tr>
        <tr>
            <td >
                <b>BİRLEŞİK SİGORTA POLİÇE PRİM TEKLİF FORMU</b></td>
        </tr>
        <tr>
            <td >
                <asp:FormView ID="FormView1" runat="server" DataSourceID="sqlacs" Width="664px" CssClass="formviewler2">
                    <EditItemTemplate>
                        userid:
                        <asp:Label ID="useridLabel1" runat="server" Text='<%# Eval("userid") %>' />
                        <br />
                        adisoyadi:
                        <asp:TextBox ID="adisoyadiTextBox" runat="server" 
                            Text='<%# Bind("adisoyadi") %>' />
                        <br />
                        eposta:
                        <asp:TextBox ID="epostaTextBox" runat="server" Text='<%# Bind("eposta") %>' />
                        <br />
                        tckimlikno:
                        <asp:TextBox ID="tckimliknoTextBox" runat="server" 
                            Text='<%# Bind("tckimlikno") %>' />
                        <br />
                        vergikimlikno:
                        <asp:TextBox ID="vergikimliknoTextBox" runat="server" 
                            Text='<%# Bind("vergikimlikno") %>' />
                        <br />
                        gsm:
                        <asp:TextBox ID="gsmTextBox" runat="server" Text='<%# Bind("gsm") %>' />
                        <br />
                        tel:
                        <asp:TextBox ID="telTextBox" runat="server" Text='<%# Bind("tel") %>' />
                        <br />
                        faxno:
                        <asp:TextBox ID="faxnoTextBox" runat="server" Text='<%# Bind("faxno") %>' />
                        <br />
                        teklifsirketi:
                        <asp:TextBox ID="teklifsirketiTextBox" runat="server" 
                            Text='<%# Bind("teklifsirketi") %>' />
                        <br />
                        tekliftarihi:
                        <asp:TextBox ID="tekliftarihiTextBox" runat="server" 
                            Text='<%# Bind("tekliftarihi") %>' />
                        <br />
                        SISIM:
                        <asp:TextBox ID="SISIMTextBox" runat="server" Text='<%# Bind("SISIM") %>' />
                        <br />
                        plakano:
                        <asp:TextBox ID="plakanoTextBox" runat="server" Text='<%# Bind("plakano") %>' />
                        <br />
                        aracmarka:
                        <asp:TextBox ID="aracmarkaTextBox" runat="server" 
                            Text='<%# Bind("aracmarka") %>' />
                        <br />
                        aracmodel:
                        <asp:TextBox ID="aracmodelTextBox" runat="server" 
                            Text='<%# Bind("aracmodel") %>' />
                        <br />
                        modelyil:
                        <asp:TextBox ID="modelyilTextBox" runat="server" 
                            Text='<%# Bind("modelyil") %>' />
                        <br />
                        ikametil:
                        <asp:TextBox ID="ikametilTextBox" runat="server" 
                            Text='<%# Bind("ikametil") %>' />
                        <br />
                        plakail:
                        <asp:TextBox ID="plakailTextBox" runat="server" Text='<%# Bind("plakail") %>' />
                        <br />
                        ksekli:
                        <asp:TextBox ID="ksekliTextBox" runat="server" Text='<%# Bind("ksekli") %>' />
                        <br />
                        odemetip:
                        <asp:TextBox ID="odemetipTextBox" runat="server" 
                            Text='<%# Bind("odemetip") %>' />
                        <br />
                        odemetaksit:
                        <asp:TextBox ID="odemetaksitTextBox" runat="server" 
                            Text='<%# Bind("odemetaksit") %>' />
                        <br />
                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" 
                            CommandName="Update" Text="Update" />
                        &nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server" 
                            CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        adisoyadi:
                        <asp:TextBox ID="adisoyadiTextBox" runat="server" 
                            Text='<%# Bind("adisoyadi") %>' />
                        <br />
                        eposta:
                        <asp:TextBox ID="epostaTextBox" runat="server" Text='<%# Bind("eposta") %>' />
                        <br />
                        tckimlikno:
                        <asp:TextBox ID="tckimliknoTextBox" runat="server" 
                            Text='<%# Bind("tckimlikno") %>' />
                        <br />
                        vergikimlikno:
                        <asp:TextBox ID="vergikimliknoTextBox" runat="server" 
                            Text='<%# Bind("vergikimlikno") %>' />
                        <br />
                        gsm:
                        <asp:TextBox ID="gsmTextBox" runat="server" Text='<%# Bind("gsm") %>' />
                        <br />
                        tel:
                        <asp:TextBox ID="telTextBox" runat="server" Text='<%# Bind("tel") %>' />
                        <br />
                        faxno:
                        <asp:TextBox ID="faxnoTextBox" runat="server" Text='<%# Bind("faxno") %>' />
                        <br />
                        teklifsirketi:
                        <asp:TextBox ID="teklifsirketiTextBox" runat="server" 
                            Text='<%# Bind("teklifsirketi") %>' />
                        <br />
                        tekliftarihi:
                        <asp:TextBox ID="tekliftarihiTextBox" runat="server" 
                            Text='<%# Bind("tekliftarihi") %>' />
                        <br />
                        SISIM:
                        <asp:TextBox ID="SISIMTextBox" runat="server" Text='<%# Bind("SISIM") %>' />
                        <br />
                        plakano:
                        <asp:TextBox ID="plakanoTextBox" runat="server" Text='<%# Bind("plakano") %>' />
                        <br />
                        aracmarka:
                        <asp:TextBox ID="aracmarkaTextBox" runat="server" 
                            Text='<%# Bind("aracmarka") %>' />
                        <br />
                        aracmodel:
                        <asp:TextBox ID="aracmodelTextBox" runat="server" 
                            Text='<%# Bind("aracmodel") %>' />
                        <br />
                        modelyil:
                        <asp:TextBox ID="modelyilTextBox" runat="server" 
                            Text='<%# Bind("modelyil") %>' />
                        <br />
                        ikametil:
                        <asp:TextBox ID="ikametilTextBox" runat="server" 
                            Text='<%# Bind("ikametil") %>' />
                        <br />
                        plakail:
                        <asp:TextBox ID="plakailTextBox" runat="server" Text='<%# Bind("plakail") %>' />
                        <br />
                        ksekli:
                        <asp:TextBox ID="ksekliTextBox" runat="server" Text='<%# Bind("ksekli") %>' />
                        <br />
                        odemetip:
                        <asp:TextBox ID="odemetipTextBox" runat="server" 
                            Text='<%# Bind("odemetip") %>' />
                        <br />
                        odemetaksit:
                        <asp:TextBox ID="odemetaksitTextBox" runat="server" 
                            Text='<%# Bind("odemetaksit") %>' />
                        <br />
                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" 
                            CommandName="Insert" Text="Insert" />
                        &nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server" 
                            CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                    </InsertItemTemplate>
                    <ItemTemplate>
                        <table cellpadding="0" cellspacing="0" class="style1">
                            <tr>
                                <td align="right">
                                    Teklif Tarihi:<asp:Label ID="tekliftarihiLabel" runat="server" 
                                        Text='<%# Bind("tekliftarihi") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Sayın
                                    <asp:Label ID="adisoyadiLabel" runat="server" Text='<%# Bind("adisoyadi") %>' />
                                    &nbsp;Bilgilerin geçerli olup olmadığını ve size dönüş yapmamızı istiyorsanız
                                    <br />
                                    Lütfen aşağıdaki formu dikkatlice kontrol ediniz.</td>
                            </tr>
                        </table>
                        <table cellpadding="0" cellspacing="0" class="style1">
                            <tr>
                                <td colspan="5">
                                    &nbsp;&nbsp;
                                    <asp:Label ID="SISIMLabel" runat="server" Text='<%# Bind("SISIM") %>' />
                                    &nbsp; KASKO TEKLİF FORMU</td>
                            </tr>
                            <tr>
                                <td colspan="5">
                                    TEKLİF İSTEYEN KİŞİNİN
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    E-Mail</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="epostaLabel0" runat="server" Text='<%# Bind("eposta") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Tc Kimlik No</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="tckimliknoLabel0" runat="server" 
                                        Text='<%# Bind("tckimlikno") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Vergi Kimlik No</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="vergikimliknoLabel0" runat="server" 
                                        Text='<%# Bind("vergikimlikno") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Gsm</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="gsmLabel0" runat="server" Text='<%# Bind("gsm") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Telefon</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="telLabel" runat="server" Text='<%# Bind("tel") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Fax No</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="faxnoLabel" runat="server" Text='<%# Bind("faxno") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="5">
                                    TEKLİFE KONU OLAN ARACIN:</td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Plaka No</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="plakanoLabel" runat="server" Text='<%# Bind("plakano") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Markası</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="aracmarkaLabel" runat="server" Text='<%# Bind("aracmarka") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Tipi / Modeli</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="aracmodelLabel" runat="server" Text='<%# Bind("aracmodel") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Model Yılı</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="modelyilLabel" runat="server" Text='<%# Bind("modelyil") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Sigortanın İkamet İli</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="ikametilLabel" runat="server" Text='<%# Bind("ikametil") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Aracın Plaka Kayıt İli</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="plakailLabel" runat="server" Text='<%# Bind("plakail") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Kullanım Şekli</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="ksekliLabel" runat="server" Text='<%# Bind("ksekli") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="5">
                                    ÖDEME SEÇENEKLERİ:</td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Ödeme Tipi</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="odemetipLabel" runat="server" Text='<%# Bind("odemetip") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Taksitler</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="odemetaksitLabel" runat="server" 
                                        Text='<%# Bind("odemetaksit") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    &nbsp;</td>
                                <td class="style2" colspan="3">
                                    &nbsp;</td>
                                <td class="style2">
                                    <asp:LinkButton ID="LinkButton1" runat="server">Teklifimi Gönder</asp:LinkButton>
                                    &nbsp;|&nbsp;<asp:LinkButton ID="LinkButton2" runat="server" 
                                        onclick="LinkButton2_Click">İptal Etmek İstiyorum</asp:LinkButton>
                                    &nbsp;</td>
                            </tr>
                        </table>
                    </ItemTemplate>
                </asp:FormView>
                <asp:SqlDataSource ID="sqlacs" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:acsbagla %>" 
                    DeleteCommand="DELETE FROM [tblmusteri] WHERE [userid] = ?" 
                    InsertCommand="INSERT INTO [tblmusteri] ([username], [passwordd], [adisoyadi], [eposta], [tckimlikno], [vergikimlikno], [gsm], [tel], [faxno], [ustatus], [utekstatus], [tekliftarihi], [teklifsirketi]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" 
                           
                    ProviderName="<%$ ConnectionStrings:acsbagla.ProviderName %>" 
                    SelectCommand="SELECT tblmusteri.userid, tblmusteri.adisoyadi, tblmusteri.eposta, tblmusteri.tckimlikno, tblmusteri.vergikimlikno, tblmusteri.gsm, tblmusteri.tel, tblmusteri.faxno, tblmusteri.teklifsirketi, tblmusteri.tekliftarihi, SSIRKETLERI.SISIM, tblkasko.plakano, tblkasko.aracmarka, tblkasko.aracmodel, tblkasko.modelyil, tblkasko.ikametil, tblkasko.plakail, tblkasko.ksekli, tblkasko.odemetip, tblkasko.odemetaksit FROM ((tblmusteri INNER JOIN tblkasko ON tblmusteri.userid = tblkasko.userid) INNER JOIN SSIRKETLERI ON tblkasko.kurum_firma = SSIRKETLERI.SID) WHERE (tblmusteri.userid = ?)" 
                    
                    
                    
                    UpdateCommand="UPDATE [tblmusteri] SET [username] = ?, [passwordd] = ?, [adisoyadi] = ?, [eposta] = ?, [tckimlikno] = ?, [vergikimlikno] = ?, [gsm] = ?, [tel] = ?, [faxno] = ?, [ustatus] = ?, [utekstatus] = ?, [tekliftarihi] = ?, [teklifsirketi] = ? WHERE [userid] = ?">
                  
                    <SelectParameters>
                        <asp:SessionParameter Name="?" SessionField="UID" />
                    </SelectParameters>
                  
                    <DeleteParameters>
                        <asp:Parameter Name="userid" Type="Int32" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="username" Type="String" />
                        <asp:Parameter Name="passwordd" Type="String" />
                        <asp:Parameter Name="adisoyadi" Type="String" />
                        <asp:Parameter Name="eposta" Type="String" />
                        <asp:Parameter Name="tckimlikno" Type="String" />
                        <asp:Parameter Name="vergikimlikno" Type="String" />
                        <asp:Parameter Name="gsm" Type="String" />
                        <asp:Parameter Name="tel" Type="String" />
                        <asp:Parameter Name="faxno" Type="String" />
                        <asp:Parameter Name="ustatus" Type="String" />
                        <asp:Parameter Name="utekstatus" Type="Boolean" />
                        <asp:Parameter Name="tekliftarihi" Type="DateTime" />
                        <asp:Parameter Name="teklifsirketi" Type="String" />
                        <asp:Parameter Name="userid" Type="Int32" />
                    </UpdateParameters>
                    <InsertParameters>
                        <asp:Parameter Name="username" Type="String" />
                        <asp:Parameter Name="passwordd" Type="String" />
                        <asp:Parameter Name="adisoyadi" Type="String" />
                        <asp:Parameter Name="eposta" Type="String" />
                        <asp:Parameter Name="tckimlikno" Type="String" />
                        <asp:Parameter Name="vergikimlikno" Type="String" />
                        <asp:Parameter Name="gsm" Type="String" />
                        <asp:Parameter Name="tel" Type="String" />
                        <asp:Parameter Name="faxno" Type="String" />
                        <asp:Parameter Name="ustatus" Type="String" />
                        <asp:Parameter Name="utekstatus" Type="Boolean" />
                        <asp:Parameter Name="tekliftarihi" Type="DateTime"/>
                        <asp:Parameter Name="teklifsirketi" Type="String" />
                    </InsertParameters>
                </asp:SqlDataSource>
                <br />
                </td>
        </tr>
        
    </table>
        </asp:View>
        <asp:View ID="View2" runat="server">
         <table cellpadding="0" cellspacing="0" width="100%" bgcolor="white">
        <tr>
            <td class="style5">
                <b>SAĞLIK</b></td>
        </tr>
        <tr>
            <td >
                <b>BİRLEŞİK SİGORTA POLİÇE PRİM TEKLİF FORMU</b></td>
        </tr>
        <tr>
            <td >
                <asp:FormView ID="FormView2" runat="server" DataSourceID="SqlDataSource1" 
                    Width="664px" CssClass="formviewler2">
                    <EditItemTemplate>
                        userid:
                        <asp:Label ID="useridLabel1" runat="server" Text='<%# Eval("userid") %>' />
                        <br />
                        adisoyadi:
                        <asp:TextBox ID="adisoyadiTextBox" runat="server" 
                            Text='<%# Bind("adisoyadi") %>' />
                        <br />
                        eposta:
                        <asp:TextBox ID="epostaTextBox" runat="server" Text='<%# Bind("eposta") %>' />
                        <br />
                        tckimlikno:
                        <asp:TextBox ID="tckimliknoTextBox" runat="server" 
                            Text='<%# Bind("tckimlikno") %>' />
                        <br />
                        vergikimlikno:
                        <asp:TextBox ID="vergikimliknoTextBox" runat="server" 
                            Text='<%# Bind("vergikimlikno") %>' />
                        <br />
                        gsm:
                        <asp:TextBox ID="gsmTextBox" runat="server" Text='<%# Bind("gsm") %>' />
                        <br />
                        tel:
                        <asp:TextBox ID="telTextBox" runat="server" Text='<%# Bind("tel") %>' />
                        <br />
                        faxno:
                        <asp:TextBox ID="faxnoTextBox" runat="server" Text='<%# Bind("faxno") %>' />
                        <br />
                        teklifsirketi:
                        <asp:TextBox ID="teklifsirketiTextBox" runat="server" 
                            Text='<%# Bind("teklifsirketi") %>' />
                        <br />
                        tekliftarihi:
                        <asp:TextBox ID="tekliftarihiTextBox" runat="server" 
                            Text='<%# Bind("tekliftarihi") %>' />
                        <br />
                        SISIM:
                        <asp:TextBox ID="SISIMTextBox" runat="server" Text='<%# Bind("SISIM") %>' />
                        <br />
                        cinsiyet:
                        <asp:TextBox ID="cinsiyetTextBox" runat="server" 
                            Text='<%# Bind("cinsiyet") %>' />
                        <br />
                        dogumtarihi:
                        <asp:TextBox ID="dogumtarihiTextBox" runat="server" 
                            Text='<%# Bind("dogumtarihi") %>' />
                        <br />
                        kangrubu:
                        <asp:TextBox ID="kangrubuTextBox" runat="server" 
                            Text='<%# Bind("kangrubu") %>' />
                        <br />
                        boy:
                        <asp:TextBox ID="boyTextBox" runat="server" 
                            Text='<%# Bind("boy") %>' />
                        <br />
                        kilo:
                        <asp:TextBox ID="kiloTextBox" runat="server" 
                            Text='<%# Bind("kilo") %>' />
                        <br />
                        odemetip:
                        <asp:TextBox ID="odemetipTextBox" runat="server" 
                            Text='<%# Bind("odemetip") %>' />
                        <br />
                        odemetaksit:
                        <asp:TextBox ID="odemetaksitTextBox" runat="server" 
                            Text='<%# Bind("odemetaksit") %>' />
                        <br />
                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" 
                            CommandName="Update" Text="Update" />
&nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" 
                            CommandName="Cancel" Text="Cancel" />
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        adisoyadi:
                        <asp:TextBox ID="adisoyadiTextBox" runat="server" 
                            Text='<%# Bind("adisoyadi") %>' />
                        <br />
                        eposta:
                        <asp:TextBox ID="epostaTextBox" runat="server" Text='<%# Bind("eposta") %>' />
                        <br />
                        tckimlikno:
                        <asp:TextBox ID="tckimliknoTextBox" runat="server" 
                            Text='<%# Bind("tckimlikno") %>' />
                        <br />
                        vergikimlikno:
                        <asp:TextBox ID="vergikimliknoTextBox" runat="server" 
                            Text='<%# Bind("vergikimlikno") %>' />
                        <br />
                        gsm:
                        <asp:TextBox ID="gsmTextBox" runat="server" Text='<%# Bind("gsm") %>' />
                        <br />
                        tel:
                        <asp:TextBox ID="telTextBox" runat="server" Text='<%# Bind("tel") %>' />
                        <br />
                        faxno:
                        <asp:TextBox ID="faxnoTextBox" runat="server" Text='<%# Bind("faxno") %>' />
                        <br />
                        teklifsirketi:
                        <asp:TextBox ID="teklifsirketiTextBox" runat="server" 
                            Text='<%# Bind("teklifsirketi") %>' />
                        <br />
                        tekliftarihi:
                        <asp:TextBox ID="tekliftarihiTextBox" runat="server" 
                            Text='<%# Bind("tekliftarihi") %>' />
                        <br />
                        SISIM:
                        <asp:TextBox ID="SISIMTextBox" runat="server" Text='<%# Bind("SISIM") %>' />
                        <br />
                        cinsiyet:
                        <asp:TextBox ID="cinsiyetTextBox" runat="server" 
                            Text='<%# Bind("cinsiyet") %>' />
                        <br />
                        dogumtarihi:
                        <asp:TextBox ID="dogumtarihiTextBox" runat="server" 
                            Text='<%# Bind("dogumtarihi") %>' />
                        <br />
                        kangrubu:
                        <asp:TextBox ID="kangrubuTextBox" runat="server" 
                            Text='<%# Bind("kangrubu") %>' />
                        <br />
                        boy:
                        <asp:TextBox ID="boyTextBox" runat="server" 
                            Text='<%# Bind("boy") %>' />
                        <br />
                        kilo:
                        <asp:TextBox ID="kiloTextBox" runat="server" 
                            Text='<%# Bind("kilo") %>' />
                        <br />
                        odemetip:
                        <asp:TextBox ID="odemetipTextBox" runat="server" 
                            Text='<%# Bind("odemetip") %>' />
                        <br />
                        odemetaksit:
                        <asp:TextBox ID="odemetaksitTextBox" runat="server" 
                            Text='<%# Bind("odemetaksit") %>' />
                        <br />
                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" 
                            CommandName="Insert" Text="Insert" />
&nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" 
                            CommandName="Cancel" Text="Cancel" />
                    </InsertItemTemplate>
                    <ItemTemplate>
                     <table cellpadding="0" cellspacing="0" class="style1">
                            <tr>
                                <td align="right">
                                    Teklif Tarihi:<asp:Label ID="Label1" runat="server" 
                                        Text='<%# Bind("tekliftarihi") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Sayın
                                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("adisoyadi") %>' />
                                    &nbsp;Bilgilerin geçerli olup olmadığını ve size dönüş yapmamızı istiyorsanız
                                    <br />
                                    Lütfen aşağıdaki formu dikkatlice kontrol ediniz.</td>
                            </tr>
                        </table>
                        <table cellpadding="0" cellspacing="0" class="style1">
                            <tr>
                                <td colspan="5">
                                    &nbsp;&nbsp;
                                    <asp:Label ID="Label3" runat="server" Text='<%# Bind("SISIM") %>' />
                                    &nbsp; SAĞLIK TEKLİF FORMU</td>
                            </tr>
                            <tr>
                                <td colspan="5">
                                    TEKLİF İSTEYEN KİŞİNİN
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    E-Mail</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="epostaLabel0" runat="server" Text='<%# Bind("eposta") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Tc Kimlik No</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="tckimliknoLabel0" runat="server" 
                                        Text='<%# Bind("tckimlikno") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Vergi Kimlik No</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="vergikimliknoLabel0" runat="server" 
                                        Text='<%# Bind("vergikimlikno") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Gsm</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="gsmLabel0" runat="server" Text='<%# Bind("gsm") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Telefon</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="Label4" runat="server" Text='<%# Bind("tel") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Fax No</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="Label5" runat="server" Text='<%# Bind("faxno") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="5">
                                    TEKLİFE KONU KİŞİNİN:</td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Cinsiyet</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="cinsiyetLabel" runat="server" Text='<%# Bind("cinsiyet") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Doğum Tarihi</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="dogumtarihiLabel" runat="server" 
                                        Text='<%# Bind("dogumtarihi") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Kan Grubu</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="kangrubuLabel" runat="server" Text='<%# Bind("kangrubu") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Boy</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="boyLabel" runat="server" Text='<%# Bind("boy") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Kilo</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="kiloLabel" runat="server" Text='<%# Bind("kilo") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="5">
                                    ÖDEME SEÇENEKLERİ:</td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Ödeme Tipi</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="Label6" runat="server" Text='<%# Bind("odemetip") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Taksitler</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="Label7" runat="server" Text='<%# Bind("odemetaksit") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    &nbsp;</td>
                                <td class="style2" colspan="3">
                                    &nbsp;</td>
                                <td class="style2">
                                    <asp:LinkButton ID="LinkButton1" runat="server">Teklifimi Gönder</asp:LinkButton>
                                    &nbsp;|&nbsp;<asp:LinkButton ID="LinkButton2" runat="server" 
                                        onclick="LinkButton2_Click1">İptal Etmek İstiyorum</asp:LinkButton>
                                    &nbsp;</td>
                            </tr>
                        </table>
                    </ItemTemplate>
                </asp:FormView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:acsbagla %>" 
                    DeleteCommand="DELETE FROM [tblmusteri] WHERE [userid] = ?" 
                    InsertCommand="INSERT INTO [tblmusteri] ([username], [passwordd], [adisoyadi], [eposta], [tckimlikno], [vergikimlikno], [gsm], [tel], [faxno], [ustatus], [utekstatus], [tekliftarihi], [teklifsirketi]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" 
                           
                    ProviderName="<%$ ConnectionStrings:acsbagla.ProviderName %>" 
                    SelectCommand="SELECT tblmusteri.userid, tblmusteri.adisoyadi, tblmusteri.eposta, tblmusteri.tckimlikno, tblmusteri.vergikimlikno, tblmusteri.gsm, tblmusteri.tel, tblmusteri.faxno, tblmusteri.teklifsirketi, tblmusteri.tekliftarihi, SSIRKETLERI.SISIM, tblsaglik.cinsiyet, tblsaglik.dogumtarihi, tblsaglik.kangrubu, tblsaglik.boy, tblsaglik.kilo, tblsaglik.odemetip, tblsaglik.odemetaksit FROM ((tblmusteri INNER JOIN tblsaglik ON tblmusteri.userid = tblsaglik.userid) INNER JOIN SSIRKETLERI ON tblsaglik.kurum_firma = SSIRKETLERI.SID) WHERE (tblmusteri.userid = ?)" 
                    
                    
                    
                    
                    
                    
                    UpdateCommand="UPDATE [tblmusteri] SET [username] = ?, [passwordd] = ?, [adisoyadi] = ?, [eposta] = ?, [tckimlikno] = ?, [vergikimlikno] = ?, [gsm] = ?, [tel] = ?, [faxno] = ?, [ustatus] = ?, [utekstatus] = ?, [tekliftarihi] = ?, [teklifsirketi] = ? WHERE [userid] = ?">
                  
                    <SelectParameters>
                        <asp:SessionParameter Name="?" SessionField="UID" />
                    </SelectParameters>
                  
                    <DeleteParameters>
                        <asp:Parameter Name="userid" Type="Int32" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="username" Type="String" />
                        <asp:Parameter Name="passwordd" Type="String" />
                        <asp:Parameter Name="adisoyadi" Type="String" />
                        <asp:Parameter Name="eposta" Type="String" />
                        <asp:Parameter Name="tckimlikno" Type="String" />
                        <asp:Parameter Name="vergikimlikno" Type="String" />
                        <asp:Parameter Name="gsm" Type="String" />
                        <asp:Parameter Name="tel" Type="String" />
                        <asp:Parameter Name="faxno" Type="String" />
                        <asp:Parameter Name="ustatus" Type="String" />
                        <asp:Parameter Name="utekstatus" Type="Boolean" />
                        <asp:Parameter Name="tekliftarihi" Type="DateTime" />
                        <asp:Parameter Name="teklifsirketi" Type="String" />
                        <asp:Parameter Name="userid" Type="Int32" />
                    </UpdateParameters>
                    <InsertParameters>
                        <asp:Parameter Name="username" Type="String" />
                        <asp:Parameter Name="passwordd" Type="String" />
                        <asp:Parameter Name="adisoyadi" Type="String" />
                        <asp:Parameter Name="eposta" Type="String" />
                        <asp:Parameter Name="tckimlikno" Type="String" />
                        <asp:Parameter Name="vergikimlikno" Type="String" />
                        <asp:Parameter Name="gsm" Type="String" />
                        <asp:Parameter Name="tel" Type="String" />
                        <asp:Parameter Name="faxno" Type="String" />
                        <asp:Parameter Name="ustatus" Type="String" />
                        <asp:Parameter Name="utekstatus" Type="Boolean" />
                        <asp:Parameter Name="tekliftarihi" Type="DateTime"/>
                        <asp:Parameter Name="teklifsirketi" Type="String" />
                    </InsertParameters>
                </asp:SqlDataSource>
                <br />
                </td>
        </tr>
             
    </table>
        </asp:View>
        
        <asp:View ID="View3" runat="server">
        
            <table cellpadding="0" cellspacing="0" width="100%" bgcolor="white">
        <tr>
            <td>
                <b>KONUT</b></td>
        </tr>
        <tr>
            <td >
                <b>BİRLEŞİK SİGORTA POLİÇE PRİM TEKLİF FORMU</b></td>
        </tr>
        <tr>
            <td >
                <asp:FormView ID="FormView3" runat="server" DataSourceID="SqlDataSource2" CssClass="formviewler2" 
                    Width="664px">
                    <EditItemTemplate>
                        userid:
                        <asp:Label ID="useridLabel1" runat="server" Text='<%# Eval("userid") %>' />
                        <br />
                        adisoyadi:
                        <asp:TextBox ID="adisoyadiTextBox" runat="server" 
                            Text='<%# Bind("adisoyadi") %>' />
                        <br />
                        eposta:
                        <asp:TextBox ID="epostaTextBox" runat="server" Text='<%# Bind("eposta") %>' />
                        <br />
                        tckimlikno:
                        <asp:TextBox ID="tckimliknoTextBox" runat="server" 
                            Text='<%# Bind("tckimlikno") %>' />
                        <br />
                        vergikimlikno:
                        <asp:TextBox ID="vergikimliknoTextBox" runat="server" 
                            Text='<%# Bind("vergikimlikno") %>' />
                        <br />
                        gsm:
                        <asp:TextBox ID="gsmTextBox" runat="server" Text='<%# Bind("gsm") %>' />
                        <br />
                        tel:
                        <asp:TextBox ID="telTextBox" runat="server" Text='<%# Bind("tel") %>' />
                        <br />
                        faxno:
                        <asp:TextBox ID="faxnoTextBox" runat="server" Text='<%# Bind("faxno") %>' />
                        <br />
                        teklifsirketi:
                        <asp:TextBox ID="teklifsirketiTextBox" runat="server" 
                            Text='<%# Bind("teklifsirketi") %>' />
                        <br />
                        tekliftarihi:
                        <asp:TextBox ID="tekliftarihiTextBox" runat="server" 
                            Text='<%# Bind("tekliftarihi") %>' />
                        <br />
                        SISIM:
                        <asp:TextBox ID="SISIMTextBox" runat="server" Text='<%# Bind("SISIM") %>' />
                        <br />
                        konutil:
                        <asp:TextBox ID="konutilTextBox" runat="server" Text='<%# Bind("konutil") %>' />
                        <br />
                        konutilce:
                        <asp:TextBox ID="konutilceTextBox" runat="server" 
                            Text='<%# Bind("konutilce") %>' />
                        <br />
                        konuttipi:
                        <asp:TextBox ID="konuttipiTextBox" runat="server" 
                            Text='<%# Bind("konuttipi") %>' />
                        <br />
                        konutyapi:
                        <asp:TextBox ID="konutyapiTextBox" runat="server" 
                            Text='<%# Bind("konutyapi") %>' />
                        <br />
                        konutkull:
                        <asp:TextBox ID="konutkullTextBox" runat="server" 
                            Text='<%# Bind("konutkull") %>' />
                        <br />
                        odemetip:
                        <asp:TextBox ID="odemetipTextBox" runat="server" 
                            Text='<%# Bind("odemetip") %>' />
                        <br />
                        odemetaksit:
                        <asp:TextBox ID="odemetaksitTextBox" runat="server" 
                            Text='<%# Bind("odemetaksit") %>' />
                        <br />
                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" 
                            CommandName="Update" Text="Update" />
                        &nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server" 
                            CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        adisoyadi:
                        <asp:TextBox ID="adisoyadiTextBox" runat="server" 
                            Text='<%# Bind("adisoyadi") %>' />
                        <br />
                        eposta:
                        <asp:TextBox ID="epostaTextBox" runat="server" Text='<%# Bind("eposta") %>' />
                        <br />
                        tckimlikno:
                        <asp:TextBox ID="tckimliknoTextBox" runat="server" 
                            Text='<%# Bind("tckimlikno") %>' />
                        <br />
                        vergikimlikno:
                        <asp:TextBox ID="vergikimliknoTextBox" runat="server" 
                            Text='<%# Bind("vergikimlikno") %>' />
                        <br />
                        gsm:
                        <asp:TextBox ID="gsmTextBox" runat="server" Text='<%# Bind("gsm") %>' />
                        <br />
                        tel:
                        <asp:TextBox ID="telTextBox" runat="server" Text='<%# Bind("tel") %>' />
                        <br />
                        faxno:
                        <asp:TextBox ID="faxnoTextBox" runat="server" Text='<%# Bind("faxno") %>' />
                        <br />
                        teklifsirketi:
                        <asp:TextBox ID="teklifsirketiTextBox" runat="server" 
                            Text='<%# Bind("teklifsirketi") %>' />
                        <br />
                        tekliftarihi:
                        <asp:TextBox ID="tekliftarihiTextBox" runat="server" 
                            Text='<%# Bind("tekliftarihi") %>' />
                        <br />
                        SISIM:
                        <asp:TextBox ID="SISIMTextBox" runat="server" Text='<%# Bind("SISIM") %>' />
                        <br />
                        konutil:
                        <asp:TextBox ID="konutilTextBox" runat="server" Text='<%# Bind("konutil") %>' />
                        <br />
                        konutilce:
                        <asp:TextBox ID="konutilceTextBox" runat="server" 
                            Text='<%# Bind("konutilce") %>' />
                        <br />
                        konuttipi:
                        <asp:TextBox ID="konuttipiTextBox" runat="server" 
                            Text='<%# Bind("konuttipi") %>' />
                        <br />
                        konutyapi:
                        <asp:TextBox ID="konutyapiTextBox" runat="server" 
                            Text='<%# Bind("konutyapi") %>' />
                        <br />
                        konutkull:
                        <asp:TextBox ID="konutkullTextBox" runat="server" 
                            Text='<%# Bind("konutkull") %>' />
                        <br />
                        odemetip:
                        <asp:TextBox ID="odemetipTextBox" runat="server" 
                            Text='<%# Bind("odemetip") %>' />
                        <br />
                        odemetaksit:
                        <asp:TextBox ID="odemetaksitTextBox" runat="server" 
                            Text='<%# Bind("odemetaksit") %>' />
                        <br />
                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" 
                            CommandName="Insert" Text="Insert" />
                        &nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server" 
                            CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                    </InsertItemTemplate>
                    <ItemTemplate>
                        <table cellpadding="0" cellspacing="0" class="style1">
                            <tr>
                                <td align="right">
                                    Teklif Tarihi:<asp:Label ID="Label1" runat="server" 
                                        Text='<%# Bind("tekliftarihi") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Sayın
                                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("adisoyadi") %>' />
                                    &nbsp;Bilgilerin geçerli olup olmadığını ve size dönüş yapmamızı istiyorsanız
                                    <br />
                                    Lütfen aşağıdaki formu dikkatlice kontrol ediniz.</td>
                            </tr>
                        </table>
                        <table cellpadding="0" cellspacing="0" class="style1">
                            <tr>
                                <td colspan="5">
                                    &nbsp;&nbsp;
                                    <asp:Label ID="Label3" runat="server" Text='<%# Bind("SISIM") %>' />
                                    &nbsp; KONUT TEKLİF FORMU</td>
                            </tr>
                            <tr>
                                <td colspan="5">
                                    TEKLİF İSTEYEN KİŞİNİN
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    E-Mail</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="epostaLabel0" runat="server" Text='<%# Bind("eposta") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Tc Kimlik No</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="tckimliknoLabel0" runat="server" 
                                        Text='<%# Bind("tckimlikno") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Vergi Kimlik No</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="vergikimliknoLabel0" runat="server" 
                                        Text='<%# Bind("vergikimlikno") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Gsm</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="gsmLabel0" runat="server" Text='<%# Bind("gsm") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Telefon</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="Label4" runat="server" Text='<%# Bind("tel") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="2">
                                    Fax No</td>
                                <td class="style3">
                                    :</td>
                                <td colspan="2">
                                    <asp:Label ID="Label5" runat="server" Text='<%# Bind("faxno") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="5">
                                    TEKLİFE KONU OLAN KONUTUN</td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    İL</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="konutilLabel" runat="server" Text='<%# Bind("konutil") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    İLÇE</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="konutilceLabel" runat="server" Text='<%# Bind("konutilce") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    TİPİ</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="konutilceLabel0" runat="server" 
                                        Text='<%# Bind("konuttipi") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    YAPI</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="konutyapiLabel" runat="server" Text='<%# Bind("konutyapi") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    KONUT KULLANIMI</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="konutkullLabel" runat="server" Text='<%# Bind("konutkull") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2" colspan="5">
                                    ÖDEME SEÇENEKLERİ:</td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Ödeme Tipi</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="Label6" runat="server" Text='<%# Bind("odemetip") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    Taksitler</td>
                                <td class="style2" colspan="3">
                                    :</td>
                                <td class="style2">
                                    <asp:Label ID="Label7" runat="server" Text='<%# Bind("odemetaksit") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    &nbsp;</td>
                                <td class="style2" colspan="3">
                                    &nbsp;</td>
                                <td class="style2">
                                    <asp:LinkButton ID="LinkButton1" runat="server">Teklifimi Gönder</asp:LinkButton>
                                    &nbsp;|&nbsp;<asp:LinkButton ID="LinkButton2" runat="server" 
                                        onclick="LinkButton2_Click2">İptal Etmek İstiyorum</asp:LinkButton>
                                    &nbsp;</td>
                            </tr>
                        </table>
                    </ItemTemplate>
                </asp:FormView>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:acsbagla %>" 
                    DeleteCommand="DELETE FROM [tblmusteri] WHERE [userid] = ?" 
                    InsertCommand="INSERT INTO [tblmusteri] ([username], [passwordd], [adisoyadi], [eposta], [tckimlikno], [vergikimlikno], [gsm], [tel], [faxno], [ustatus], [utekstatus], [tekliftarihi], [teklifsirketi]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" 
                           
                    ProviderName="<%$ ConnectionStrings:acsbagla.ProviderName %>" 
                    SelectCommand="SELECT tblmusteri.userid, tblmusteri.adisoyadi, tblmusteri.eposta, tblmusteri.tckimlikno, tblmusteri.vergikimlikno, tblmusteri.gsm, tblmusteri.tel, tblmusteri.faxno, tblmusteri.teklifsirketi, tblmusteri.tekliftarihi, SSIRKETLERI.SISIM, tblkonut.konutil, tblkonut.konutilce, tblkonut.konuttipi, tblkonut.konutyapi, tblkonut.konutkull, tblkonut.odemetip, tblkonut.odemetaksit FROM ((tblmusteri INNER JOIN tblkonut ON tblmusteri.userid = tblkonut.userid) INNER JOIN SSIRKETLERI ON tblkonut.kurum_firma = SSIRKETLERI.SID) WHERE (tblmusteri.userid = ?)" 
                    
                    
                    
                    
                    
                    UpdateCommand="UPDATE [tblmusteri] SET [username] = ?, [passwordd] = ?, [adisoyadi] = ?, [eposta] = ?, [tckimlikno] = ?, [vergikimlikno] = ?, [gsm] = ?, [tel] = ?, [faxno] = ?, [ustatus] = ?, [utekstatus] = ?, [tekliftarihi] = ?, [teklifsirketi] = ? WHERE [userid] = ?">
                  
                   
                  
                    <SelectParameters>
                        <asp:SessionParameter Name="?" SessionField="UID" />
                    </SelectParameters>
                  
                   
                  
                    <DeleteParameters>
                        <asp:Parameter Name="userid" Type="Int32" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="username" Type="String" />
                        <asp:Parameter Name="passwordd" Type="String" />
                        <asp:Parameter Name="adisoyadi" Type="String" />
                        <asp:Parameter Name="eposta" Type="String" />
                        <asp:Parameter Name="tckimlikno" Type="String" />
                        <asp:Parameter Name="vergikimlikno" Type="String" />
                        <asp:Parameter Name="gsm" Type="String" />
                        <asp:Parameter Name="tel" Type="String" />
                        <asp:Parameter Name="faxno" Type="String" />
                        <asp:Parameter Name="ustatus" Type="String" />
                        <asp:Parameter Name="utekstatus" Type="Boolean" />
                        <asp:Parameter Name="tekliftarihi" Type="DateTime" />
                        <asp:Parameter Name="teklifsirketi" Type="String" />
                        <asp:Parameter Name="userid" Type="Int32" />
                    </UpdateParameters>
                    <InsertParameters>
                        <asp:Parameter Name="username" Type="String" />
                        <asp:Parameter Name="passwordd" Type="String" />
                        <asp:Parameter Name="adisoyadi" Type="String" />
                        <asp:Parameter Name="eposta" Type="String" />
                        <asp:Parameter Name="tckimlikno" Type="String" />
                        <asp:Parameter Name="vergikimlikno" Type="String" />
                        <asp:Parameter Name="gsm" Type="String" />
                        <asp:Parameter Name="tel" Type="String" />
                        <asp:Parameter Name="faxno" Type="String" />
                        <asp:Parameter Name="ustatus" Type="String" />
                        <asp:Parameter Name="utekstatus" Type="Boolean" />
                        <asp:Parameter Name="tekliftarihi" Type="DateTime"/>
                        <asp:Parameter Name="teklifsirketi" Type="String" />
                    </InsertParameters>
                </asp:SqlDataSource>
                <br />
                </td>
        </tr>
        
    </table>
        </asp:View>
        
        <asp:View ID="View4" runat="server">
            <table cellpadding="0" cellspacing="0" bgcolor="white" class="listeler">
                <tr>
                    <td style="text-align: center" >
                        Doldurmuş olduğunuz form isteğiniz üzerine iptal edilmiştir
                    </td>
                </tr>
                <tr>
                    <td class="style1" >
                        Tekrar denemek için </b>
                        <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/default.aspx">tıklayınız</asp:HyperLink>
                    </td>
                </tr>
            </table>
        </asp:View>
        
    </asp:MultiView>
</asp:Content>

